package com.example.dao;

import com.example.pojo.Admin;
import com.example.pojo.Announce;
import com.example.pojo.Help;
import com.example.utils.DBConnection;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public interface AdminDao {
    public Admin login(String username, String password);

    public Map<String,Object> getTopicData();

    public Map<String,Object> getTypeCount();

    public List<Map<String,Object>> getUserList();

    public Integer addUser(String username,String password,String nickname,String name,String sex,String avatar,
                           String phone,String idNumber,String enterYear,String className,String subject,String email);

    public List<Map<String,Object>> getTopicList();

    public List<Announce> getAnnounceList();

    public List<Help> getHelpList();

    public Integer insertAnnounce(Integer aId,String avatar,String title,String content);

    public Integer insertHelp(Integer aId,String avatar,String title,String content);

    public Integer deleteTopic(Integer tId);

    public Integer checkTopic(Integer tId,String checkStatus);
}
